UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b7kYz/BScUpNDGpgPH0KvWEeUPFmEtY5w81YPxL9Pps='
WHERE
key_id = '2489a17f13035f56e7fdf7a29544e5f5c1f8c9fcc9c67aa2ad82184fe6e4412f'
AND (
token = 'b7kYz/BScUpNDGpgPH0KvWEeUPFmEtY5w81YPxL9Pps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)