UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0jBum1ldc50cXkGxf+10Md5qFIYDsMP4ZeDT7vbzdj0='
WHERE
key_id = '94fadee5e568338618d035671f599a1aa80f41a68a24dee34480f3e9dbfb2040'
AND (
token = '0jBum1ldc50cXkGxf+10Md5qFIYDsMP4ZeDT7vbzdj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)