UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U5j578IBaGb6p3VAZCIPJhx5SUaUPwbNA3iKW7/jfjU='
WHERE
key_id = 'c1b1da58baac366909d52b7bd220295270d4dad306aa41315ee90749f67a6189'
AND (
token = 'U5j578IBaGb6p3VAZCIPJhx5SUaUPwbNA3iKW7/jfjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)