UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6qqcUkQR9Wb4aV8xeHBg8dEL6tRShVVSgEh3KIugpl0='
WHERE
key_id = '648109c93c577e0ef34380767407cc073aa78b5c480a1df044232592cd295732'
AND (
token = '6qqcUkQR9Wb4aV8xeHBg8dEL6tRShVVSgEh3KIugpl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)