UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H+I9oX4oP1rsOrN4YtbpCZOAshn7RH2Hj45/tkFbWaM='
WHERE
key_id = '9abf7125ebd120f06d348041b59f1ec848921ce791fa13e918e55425f75568ad'
AND (
token = 'H+I9oX4oP1rsOrN4YtbpCZOAshn7RH2Hj45/tkFbWaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)