UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgtN9KiWM9EVVLBUt6mQDfZ/XdD8bCZgQT7IkRQv/dU='
WHERE
key_id = '5ef31eb8e050962c46087e88ec54be45a249da23321dddcad53c4d3939ff5f88'
AND (
token = 'JgtN9KiWM9EVVLBUt6mQDfZ/XdD8bCZgQT7IkRQv/dU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)