UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zC0YkzVOigejdefHcm05HzyINhZnfOBVeUzVxm46K64='
WHERE
key_id = '547dd6f818bf4a36db3a72a2826c088dafb26a8e67486a970666a7573bc54456'
AND (
token = 'zC0YkzVOigejdefHcm05HzyINhZnfOBVeUzVxm46K64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)