UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KTwE8vjVk/CPzegYGCNC1bCMuDdVw9haOfej2d8vpxA='
WHERE
key_id = '0590e211da9c84bc929c0b8f1b61c9facb9583419700686801a6d6710b87aa35'
AND (
token = 'KTwE8vjVk/CPzegYGCNC1bCMuDdVw9haOfej2d8vpxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)