UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQvQT1fUsDTaBv5DAydQvWV7rFhkcbbVS8cbtryzC84='
WHERE
key_id = 'f42492448338bf0e0c58a804a0d0f04cb25f59ed23b3cd0cb5d66656f834ef63'
AND (
token = 'hQvQT1fUsDTaBv5DAydQvWV7rFhkcbbVS8cbtryzC84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)