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