UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KGf782V0yga6do4fhAS8hwG7M1yf+5svDoVXogaH8g4='
WHERE
key_id = '86b819364e3b768fb770140e495fe1de9330dafac7e799c24795c136747bc2e3'
AND (
token = 'KGf782V0yga6do4fhAS8hwG7M1yf+5svDoVXogaH8g4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)