UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gbi0KKmmVEwARqbzKCi/KdG+NIM47wsKwkyy9I9HaJs='
WHERE
key_id = '5f8f822067fb78b753f63ab097bce0b58d0505a13a4ba564ededa260c5ab5005'
AND (
token = 'gbi0KKmmVEwARqbzKCi/KdG+NIM47wsKwkyy9I9HaJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)