UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYiPanVXjsES/hyys74TbubRth99qZzOskllZSvVLiY='
WHERE
key_id = 'e79d11b2a7a42f68f4ce88f340ce4299f7435b7b9cfb1b0e3d0e364031f830e2'
AND (
token = 'pYiPanVXjsES/hyys74TbubRth99qZzOskllZSvVLiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)