UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4Ro4iGGStdwn4WrHqtNc+mhBYe6gVPAbGrd5fNPpI4='
WHERE
key_id = '29d8dee946829f4544ea399ba10f20bddf94adefa4e9a65bbd30fdf61e5d728f'
AND (
token = 'D4Ro4iGGStdwn4WrHqtNc+mhBYe6gVPAbGrd5fNPpI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)