UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xdsi7pJ6lHKkk177/8l8SW3CGOPtfCk5MCtax4GYcRM='
WHERE
key_id = '9a05895f58e3fb1aa7f88190bdc6512d5e52a2f51ec33302b633de18bf999ae8'
AND (
token = 'xdsi7pJ6lHKkk177/8l8SW3CGOPtfCk5MCtax4GYcRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)