UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lOcj+pHJ5C9Fu8BMbw83D6UW99CNUKoIuB3qpy8plEI='
WHERE
key_id = 'dfa569114616817b5f159e6d83aea89b1f232de569b250665e5d53c4b86fbfa3'
AND (
token = 'lOcj+pHJ5C9Fu8BMbw83D6UW99CNUKoIuB3qpy8plEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)