UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GZ9j8gkJPNRmg4NocdCASlfaN7t9yQEXMYkz3wWpmx4='
WHERE
key_id = '421731d93cf786fe9cd34300a1015df103d36ee664ed86a66d2da8a91a7077b7'
AND (
token = 'GZ9j8gkJPNRmg4NocdCASlfaN7t9yQEXMYkz3wWpmx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)