UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3pao6jDc0DXOjkmmalxZS0niVIa6mv2j1IEUx3cghOc='
WHERE
key_id = 'd9099d216d98378137696f2dc50481ae75109392cd298fd22e9849f99505a33f'
AND (
token = '3pao6jDc0DXOjkmmalxZS0niVIa6mv2j1IEUx3cghOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)