UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7EVYFHAItOhFx8W0KJBKMYETAHn7XUBp0KoZS1Kn5I='
WHERE
key_id = '801ce56d89b80c7b85df99c6ce2ba2146bd75ec24bd052d5384339958fa701fc'
AND (
token = 'q7EVYFHAItOhFx8W0KJBKMYETAHn7XUBp0KoZS1Kn5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)