UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8PNjBTivm7WlZZgdkoYCZa8GLcoxDD/fwaCaNLTGAZE='
WHERE
key_id = '10c541e1caedb187263a4ea09c83aee935caa04bee73ab5f44f3577808422bf6'
AND (
token = '8PNjBTivm7WlZZgdkoYCZa8GLcoxDD/fwaCaNLTGAZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)