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