UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'INgHzFDhlO9ov4qsgWTgWCAS2aYfKY8Mu265YKHF5aA='
WHERE
key_id = 'ca9fa119123a68d8c6bd117dbab538a1073b49e2fb865baca5b0da15cd064303'
AND (
token = 'INgHzFDhlO9ov4qsgWTgWCAS2aYfKY8Mu265YKHF5aA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)