UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jxLRe4yqByZnI8CMuBoP6XFGSM4yVw76P4tZtkxJgeA='
WHERE
key_id = '309162122adbd4905d6dfa6b395eb49d9d85203f6a6283e05a9ec7d877ed140a'
AND (
token = 'jxLRe4yqByZnI8CMuBoP6XFGSM4yVw76P4tZtkxJgeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)