UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aPnYMhZusm3lw3BOQaXH2N91Udcg1XOKVkD2Sojz4o='
WHERE
key_id = 'd5849c148da9b393c9f75b8227c86a49522065e68e37f426ffc8c86dfcd9f13d'
AND (
token = '7aPnYMhZusm3lw3BOQaXH2N91Udcg1XOKVkD2Sojz4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)