UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wHbDb1PbeKUomJFcpSnF4vfqRZfLQSTC5mBCGDWcIHU='
WHERE
key_id = '0eefc72d7ae3ffefabea3ac51236898d7e3428082c9683560c256f51aec36c17'
AND (
token = 'wHbDb1PbeKUomJFcpSnF4vfqRZfLQSTC5mBCGDWcIHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)