UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P5NlwDX2nFQakxizJzqsXmSJDGYjsISDncp/PeOBqdQ='
WHERE
key_id = 'c381f0a3f711fa0d4cb80cbed62e71d9e344ef7149b1e022aa73c8b375a75934'
AND (
token = 'P5NlwDX2nFQakxizJzqsXmSJDGYjsISDncp/PeOBqdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)