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