UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9LtoFjuOaJ+4qLehRT129uACucf1A2ZFPjNJ5FP6J8='
WHERE
key_id = '0ca4c377de7b6f5f61aa8e3c33dec879dc21b1abfda2431cc10c680487d7daaf'
AND (
token = 'z9LtoFjuOaJ+4qLehRT129uACucf1A2ZFPjNJ5FP6J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)